SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 53825: A DB2 -804 error or a "column does not exist" error might occur when you join two DB2 tables in the z/OS operating environment

DetailsHotfixAboutRate It

An error might occur when you use an SQL procedure containing READBUFF= and DBSASTYPE= options to query two DB2 tables under z/OS via a LIBNAME engine. The error might look similar to one of the following two errors:

Error 1:

DB2 ERROR:
 RESULT OF SQL STATEMENT:
 DSN00804E AN ERROR WAS FOUND IN THE APPLICATION PROGRAM INPUT PARAMETERS
            FOR THE SQL STATEMENT, REASON 07
 A DUMP OF THE SQLCA FOR THE GET DIAGNOSTICS REQUEST FOLLOWS:
           ROW NUMBER: 0 ERROR CONDITION: 1 REASON CODE: 7
           SQLCODE: -804 SQLSTATE: 07002 SQLERRP: DSNXECP

 DB2     ..?-.?.?     .EMPLOYEE_ID                  DATA

Error 2:

ERROR: (ACCDB2M041E) The column xxxxxx does not exist.

Currently, the only workaround is to select a different value for the READBUFF= option. Which value to use varies per query. The default setting, READBUFF=1, should work for all queries, but it might not be the most efficient setting. Determining the best value requires testing.

Click the Hot Fix tab in this note to access the hot fix for this issue.



Operating System and Release Information

Product FamilyProductSystemSAS Release
ReportedFixed*
SAS SystemSAS/ACCESS Interface to DB2z/OS9.3 TS1M29.4 TS1M2
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.